:Base abdata.HLP 1 Ability Database 2 Getting started 3 What is a Database 4 What is a database?=What_is_a_database 4 What is a table?=What_is_a_table 4 What is a relation?=What_is_a_relation 4 What is a query component?=What_is_a_query_component 4 What is a query?=What_is_a_query 4 What is a table view?=What_is_a_table_view 3 Starting Database 4 Starting Database=Starting_Database 4 Opening a database=Opening_a_database 4 Database Manager=Database_Manager 4 Closing a database=Closing_a_database 4 Query components=Query_components 4 Opening a table=Opening_a_table 4 Moving around a table=Moving_around_a_table 2 Creating databases and tables 3 Creating a new database=Creating_a_new_database 3 Designing a new table=Designing_a_new_table 3 Fields 4 Planning field details=Planning_field_details 4 Field names=Field_names 4 Captions=Captions 4 Character field size=Character_field_size 4 Field data types 5 Data types=Data_types 5 Character=Character 5 Numeric=Numeric 5 Date=Date 5 Time=Time 5 Memo=Memo 5 Incremental=Incremental 5 Logical=Logical 5 Enumerated=Enumerated 5 Picture=Picture 5 OLE=OLE_field_type 5 Calculated 6 Calculated field type=Calculated 6 Using the calculated data type in a table=Using_the_calculated_data_type_in_a_table 6 Using the calculated data type in a relation=Using_the_calculated_data_type_in_a_relation 4 Creating fields 5 Creating fields in a database=Creating_fields_in_a_database 5 Creating fields in a database using Table Wizard=Creating_fields_in_a_database_using_Table_Wizard 5 Adding enumerated field types=Adding_enumerated_field_types 5 Masks in database fields=Masks_in_database_fields 3 Indexes 4 Indexes and primary keys=Indexes_and_primary_keys 4 Primary key=Primary_key 4 Unique indexes=Unique_indexes 4 Non-unique indexes=Non_unique_indexes 4 Creating indexes and primary keys=Creating_indexes_and_primary_keys 4 Checking indexes and primary keys=Checking_indexes_and_primary_keys 4 Editing and setting indexes and primary keys=Editing_and_setting_indexes_and_primary_keys 4 Multiple-field indexes=Multiple_field_indexes 3 Saving the new table 4 Saving a new table=Saving_a_new_table 2 Using tables 3 Opening a table using database manager=Opening_a_table_using_database_manager 3 Grid view=Grid_view 3 Table record indicators=Table_record_indicators 3 Working with records 4 Modifying records=Modifying_records 4 Adding records=Adding_records 4 Duplicating records=Duplicating_records 4 Entering data and editing records=Entering_data_and_editing_records 4 Finding records=Finding_records 4 Deleting records=Deleting_records 4 Deleting the contents of fields in a database table=Deleting_the_contents_of_fields_in_a_database_table 4 Copying records=Copying_records 3 Managing tables 4 Managing your tables=Managing_your_tables 4 Redesigning a table=Redesigning_a_table 3 Formatting the table grid 4 Formatting columns in a database table=Formatting_columns_in_a_database_table 4 Formatting fonts in a table=Formatting_fonts_in_a_table 4 Formatting a table for color=Formatting_a_table_for_color 4 Formatting database fields=Formatting_database_fields 4 Changing the grid style=Changing_the_grid_style 4 Changing the column width=Changing_the_column_width 3 Table calculations 4 Performing calculations in tables=Performing_calculations_in_tables 2 Filters, Sort Orders and Column Views 3 Column Views 4 Rearranging columns using the mouse=Rearranging_columns_using_the_mouse 4 Rearranging columns using a columns selection=Rearranging_columns_using_a_columns_selection 4 Hiding and showing columns in a database table=Hiding_and_showing_columns_in_a_database_table 4 Hiding and showing columns using a columns selection=Hiding_and_showing_columns_using_a_columns_selection 3 Sort Orders 4 Sorting a table=Sorting_a_table 4 Sorting on a single field=Sorting_on_a_single_field 4 Sorting using a sort order=Sorting_using_a_sort_order 3 Filters 4 Filtering a table=Filtering_a_table 4 Filtering on a single field=Filtering_on_a_single_field 4 Filtering using a named filter=Filtering_using_a_named_filter 4 Filter example=Filter_example 2 Queries 3 Queries=Queries 3 Creating and applying a query=Creating_and_applying_a_query 3 Creating a query while working in a table=Creating_a_query_while_working_in_a_table 3 Editing a query=Editing_a_query 3 Editing query components=Editing_query_components 2 Relations 3 Joining tables=Joining_tables 3 Creating a relation=Creating_a_relation 3 Relating tables using forms=Relating_tables_using_forms 2 Forms 3 Form view=Form_view 3 Opening an auto form=Opening_an_auto_form 3 Design mode=Design_mode 3 Opening an existing form=Opening_an_existing_form 3 Using a form 4 Using browse mode in a form=Using_browse_mode_in_a_form 4 Moving around in a form=Moving_around_in_a_form 4 Browsing through the database table=Browsing_through_the_database_table 4 Editing records=Editing_records 4 Hiding fields from the form=Hiding_fields_from_the_form 4 Showing hidden fields in the form=Showing_hidden_fields_in_the_form 3 Creating forms 4 Creating a new form=Creating_a_new_form 4 Creating a form from scratch=Creating_a_form_from_scratch 4 Inserting fields 5 Inserting fields into a form=Inserting_fields_into_a_form 5 Inserting database fields into a form=Inserting_database_fields_into_a_form 5 Inserting a database field=Inserting_a_database_field 5 Inserting a lookup field=Inserting_a_lookup_field 5 Inserting formula fields into a form or report=Inserting_formula_fields_into_a_form_or_report 5 Inserting a lookup summary field into a form or report=Inserting_a_lookup_summary_field_into_a_form_or_report 5 Using lookup summary fields in forms or reports: example=Using_lookup_summary_fields_in_forms_or_reports_example 4 Inserting table grids 5 Inserting a table grid into a form=Inserting_a_table_grid_into_a_form 5 Inserting a table grid into a form: example=Inserting_a_table_grid_into_a_form_example 4 Page numbers, dates, pictures 5 Inserting a page number into a form or report=Inserting_a_page_number_into_a_form_or_report 5 Inserting the date and time into a form or report=Inserting_the_date_and_time_into_a_form_or_report 5 Inserting a picture into a form or report=Inserting_a_picture_into_a_form_or_report 5 Inserting an object into a form=Inserting_an_object_into_a_form 3 Editing existing fields 4 Editing fields in forms and reports=Editing_fields_in_forms_and_reports 3 Multi-page forms 4 Multi-page forms=Multi_page_forms 2 Reports 3 Reporting=Reporting 3 Opening an auto report=Opening_an_auto_report 3 Detail of an auto report=Detail_of_an_auto_report 3 Opening an existing report=Opening_an_existing_report 3 Creating new reports 4 Creating new reports=Creating_new_reports 4 Types of report=Types_of_report 4 Type of report: vertical fields=Type_of_report_vertical_fields 4 Type of report: horizontal fields=Type_of_report_horizontal_fields 4 Labels in reports=Labels_in_reports 4 Inserting fields in a report=Inserting_fields_in_a_report 3 Editing reports 4 Editing a report=Editing_a_report 4 Resizing the sections in a report=Resizing_the_sections_in_a_report 4 Headers and footers in a report=Headers_and_footers_in_a_report 4 Format sections in reports=Format_sections_in_reports 4 Editing field labels=Editing_field_labels 3 Sorting and grouping 4 Sorting and grouping in a report=Sorting_and_grouping_in_a_report 4 Group summary fields=Group_summary_fields 4 Layout of a grouped report=Layout_of_a_grouped_report 4 Using queries in reports=Using_queries_in_reports 3 Viewing and printing 4 Viewing a report in print preview=Viewing_a_report_in_print_preview 4 Printing a report=Printing_a_report 2 Managing Databases 3 Deleting a database=Deleting_a_database 3 Deleting a database object=Deleting_a_database_object 3 Repairing a damaged database=Repairing_a_damaged_database 2 Importing and exporting tables 3 Importing tables=Importing_tables 3 Exporting tables=Exporting_tables 3 Appending imported tables=Appending_imported_tables